Range Samples
Add a variety of formatting, comments, grouping, hyperlinks, protection, validation, values, and merge, find, replace, filter, sort, goal seek, or fill data.

Font
Set font options.
Border
Set border style, weight and color.
Comment
Add cell comments to a worksheet.
Hyperlink
Add hyperlinks to worksheet cells.
Interior
Set fill pattern and color.
Merge Cells
Merge the currently selected range.
Number Format
Set number formats.
Orientation
Set text orientation.
Auto Filter
Use auto filters to view subsets of data in a worksheet.
Sorting
Sort a range of data.
Validation
Add data validation to worksheet cells.
Conditional Format
Add conditional formats based on specific criteria.
Goal Seek
Achieve a specific goal from a calculated result using a simple iterative linear search.
Fill Data Series
Automatically fill cells with data.
Find and Replace
Find and replace values in worksheet ranges.
Group and Outline
Group and outline ranges of cells.
Lock and Protect
Lock and unlock cells and enable worksheet protection.
Values from Array
Set cell values from an array.